EMT Practice Test

1. Question Content...

---

Question1: In an analytic application, which element can you enter comments for?

Question2: You have a planning model with the following dimensions; Cost Center, Account, Date, Entity, Version. When you add new transactional data to your model, you want to overwrite any records with cost center A and add new data for cost center B. Which import method do you use?

Question3: You enter plan values by year and product group. You want to allocate these values to months and products in proportion to last year's actual dat a. What setting in the allocation process is required to achieve this?

Question4: What are the pillars of SAP Analytics Cloud? Note: There are 3 correct answers to this question.

Question5: Which SAP Analytics Cloud Machine Learning function provides performance indicators that can be used to evaluate the accuracy of a statistical model?

Question6: Regarding comments, what can you do in analytical applications but not in stories? Note: There are 2 correct answers to this question

Question7: You are using the planning panel to distribute values. Which of the following driver options can you select? Note: There are 3 correct answers to this question.

Question8: You are creating a planning model that is based on SAP BPC, version for SAP BW/4HANA Embedded option. What sources are supported for the SAP Analytics Cloud model?

Question9: You have an SAP Business Warehouse data source with 25 key figures and no account characteristic. What must you do to import this data into an existing planning model? Note: There are 2 correct answers to this question

Question10: You have created a new SAP Analytics Cloud dimension to be used for SAP S/4HANA master dat a. To import the members, text and hierarchy data, how many data sources do you need?

Question11: Which data locking status can you use to prevent manual data entry?

Question12: You have a planning model with the following dimensions: Cost Center, Account, Date, Version. When you add new transactional data to your model, you want to add new data for cost center A and remove any records for cost center B. Which import method do you use?

Question13: In a story: you are using a planning model with currency translation enabled.
Which properties in the cross calculation editor do you have when configuring currency conversion?
Note: There are 2 correct answers to this question.

Question14: What can you do in a value driver tree with only a BI user role? Note: There are 2 correct answers to this question

Question15: In an existing planning model what currency-related setting CANNOT be changed?

Question16: How can you change plan data via the Planning Panel in a story? Note: There are 2 correct answers to this question.

Question17: You are working on a flat file-based planning model. You want to prevent manual data entry for certain data intersections. What options do you have? Note: There are 2 correct answers to this question.

Question18: How can you use a data action to copy data from one version to another while keeping the account number the same? Note: There are 2 correct answers to this question.

Question19: Which work files can you access when you run a planning process? Note: There are 2 correct answers to this question.

Question20: What data sources are available for SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct answers to this question.

Question21: Which of the following actions on the date dimension are available in Value Driver Trees? Note: There are 2 correct answers to this question.

Question22: You saved data for a certain cost center and profit center combination. Later, an administrator created a validation rule that prevents saving data against that combination. What happens when you display the data in a story?

Question23: Why would you use the SAP Analytics Cloud add-in for Microsoft Office instead of SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct answers to this question.

Question24: What can you use to restrict input in a story based on nested conditions?

Question25: You create a dimension in SAP Analytics Cloud with a hierarchy. You want to update the new dimension with data from a characteristic in SAP Business Warehouse using SAP recommended practices. To populate the members and the hierarchy, what steps must you take? Note: There are 3 correct answers to this question

Question26: You imported a transaction data file into an empty model with the results as shown in Figure A. Later, a member of the finance team wants you to import a new data file. In the new data file, you find the following differences: The value of the Labor account has increased to 1600. There is a new record for the Services account, with a value of 250. The record for the Travel account has been deleted. To achieve the result shown in Figure B, which option must you use to update the data?

Question27: When you enable currency translation for a planning model with an account dimension which object is added to the model automatically?

Question28: You are using the SAP BPC, version for SAP BW/4HANA Standard option. When importing data from a YTD model to SAP Analytics Cloud, what can you do? Note: There are 2 correct answers to this question.

Question29: Which of the following are features of an Embedded Data Action step? Note: There are 2 correct answers to this question

Question30: Which of the following can you use to create an SAP Analytics Cloud planning model? Note: There are 3 correct answers to this question.

Question31: What must you do to create a seasonal time hierarchy? Note: There are 2 correct answers to this question.

Question32: What dimension types can be used to determine currencies? Note: There are 2 correct answers to this question.

Question33: In an analytic application you want to use a data action trigger. Your customer complains that the data action trigger pushbutton is too large. How can you address this complaint?

Question34: You are using SAP Analytics Cloud and SAP BPC, version for SAP BW/4HANA Embedded option. Which of the following planning features are available for hybrid planning? Note: There are 2 correct answers to this question.

Question35: You need to schedule the import master data for the profit center, cost center, account dimensions as well as the transction dat a. Each dimension has members, text, attribites and a hierarchy. When importing from SAP Business Warehouse. How many import steps do you need?

Question36: Why would you decide to use an Analytic Application instead of a Story? Note: There are 2 correct answers to this question.

Question37: You have a planning model with the following dimensions; Cost Center, Account, Date, Entity, Version. When you add new transactional data to your model, you want to overwrite any records with cost center A and add new data for cost center B. Which import method do you use?

Question38: You need a hierarchy that is based both on the region and the country column in the same dimension. What hierarchy type can you use?

Question39: What can you do with live connections in SAP Analytics Cloud? Note: There are 2 correct answers to this question.

Question40: You have an SAP Business Warehouse data source with 25 key figures and no account characteristic. What must you do to import this data into an existing planning model? Note: There are 2 correct answers to this question.

Question41: What can you do with a data action trigger in an analytic application? Note: There are 2 correct answers to this question

Question42: You have an allocation process with 3 steps. Which of the following can be used to run only allocation step #2?

Question43: You want to import data from SAP BPC Standard. Which SAP Analytics Cloud planning model types can you use? Note: There are 2 correct answers to this question.

Question44: Your account dimension has an account for Profit that is calculated as [Revenue] - [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?

Question45: What are prerequisites for importing master data from an SAP S/4HANA system into SAP Analytics Cloud? Note: There are 2 correct answers to this question.

Question46: When you set up a copy data action, what must you do to allow the user to select the source and target version?